package jdbc;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

/**
 * insert 使用预编辑
 *
 */
public class JDBCDemo9 {
    public static void main(String[] args) {
        try(Connection connection=DBUtil.getConnection()) {
            String sql="INSERT INTO user2(username,password,nickname,age)" +
                    " VALUES (?,?,?,?)";
            PreparedStatement ps=connection.prepareStatement(sql);
            ps.setString(1,"王克晶");
            ps.setString(2,"123456");
            ps.setString(3,"克晶");
            ps.setInt(4,18);
            int num=ps.executeUpdate();
            System.out.println(num>0?"成功":"失败");
        } catch (Exception e) {
            throw new RuntimeException(e);

        }

    }
}
